﻿
create table items(
id_item int primary key identity,
Name varchar(200) not null,
amount int not null,
description varchar(200) not null,
id_image int not null,
id_type int not null,
id_location int not null,
date_a datetime not null,
active bit not null,   
FOREIGN KEY (id_image) REFERENCES images (id_image),
FOREIGN KEY (id_type) REFERENCES types (id_type),
FOREIGN KEY (id_location) REFERENCES locations (id_location))